SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 429985 LIMIT 1 [ RunTime:0.000412s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 429985 [ RunTime:0.002683s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (339998,766500,949265,336378,653747,43305,1013601,877583,701194,332917,515968,876715,695839,52893,400594,217929,507214,937198,436447,90722,1003031,563272,924061,699099,823345,371437,868152,74707,941167,1039719,535650,223162,1033576,86648,17756,1016186,35504,190094,429266,965560,441225,606216,281044,716312,459308,161799,290883,381843,547620,412401,949939,351768,612781,166475,622837,395135,443613,284205,773992,954783) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 429985 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 429985 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003135s ]