SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001548s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 458825 LIMIT 1 [ RunTime:0.000460s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 458825 [ RunTime:0.002876s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (695534,120842,465966,150420,495239,1028213,675091,59639,268722,793371,882427,233215,350197,1046814,607385,1048184,728905,639163,627238,633276,242705,1021319,429163,793401,685978,743019,1022570,865247,557977,753026,351592,952177,875125,724186,166741,631910,495366,40076,23705,563485,879901,439230,906646,463485,303707,390185,899185,745528,113520,501364,541662,758167,111160,224,274748,311288,1022954,558487,649179,589621) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001059s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 458825 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000510s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 458825 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000654s ]