SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001109s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503140 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503140 [ RunTime:0.001806s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (164762,208447,1005052,600232,14844,823200,332145,578787,910934,547315,246984,250422,539956,921366,724334,946115,538082,135751,18776,852006,873912,413681,203839,186675,492926,761401,73532,92542,679297,324294,992539,72120,650065,515840,473891,169504,223906,689089,5816,245624,1047282,126499,85028,327674,431996,939106,158043,393058,408971,543931,141224,679608,817713,199450,70266,622836,924176,386244,241592,805609) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503140 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503140 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000521s ]