SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017428 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017428 [ RunTime:0.002140s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (962333,754679,64961,1000278,26761,751393,222367,929389,644967,76449,626219,676616,532045,704386,531815,916033,499072,310832,224892,232693,970130,215080,847079,921899,768517,48782,1000329,830856,814966,304729,1033943,755589,878192,223599,549828,765871,456877,201771,527751,255123,936180,978896,901566,396627,395086,293418,783868,111647,936059,849948,647078,452368,519673,93417,631112,223075,780231,38394,217574,447026) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001085s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017428 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017428 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000414s ]