SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1047996 LIMIT 1 [ RunTime:0.000278s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1047996 [ RunTime:0.002251s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (307639,283902,55192,1020736,766756,1033317,355754,392053,210204,274175,420119,1015940,509019,800033,697533,82265,983535,69753,794560,364089,871888,835290,58893,1030250,919651,343729,352397,1039970,1015888,900114,800389,366858,8733,593604,654263,968240,47021,961064,1044268,753538,568691,570076,583059,900185,982943,363661,533941,1022562,653581,127698,758155,355147,498096,441759,845110,789830,533713,981848,158334,725396) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000951s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1047996 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000334s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1047996 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001437s ]