SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 541593 LIMIT 1 [ RunTime:0.000630s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 541593 [ RunTime:0.002809s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (172945,393369,414037,19166,212148,329459,608355,721790,702389,389841,455551,296865,513981,329613,707850,189949,772131,249651,908816,99448,23439,356576,161872,513519,647698,691397,234059,28853,568866,678521,711910,687708,450048,494605,751236,25701,914766,328645,398880,351566,839985,858492,702425,967530,455047,471513,141806,869031,78791,885209,95228,831614,652669,382274,951274,388641,203725,918237,10685,984053) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001639s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 541593 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000602s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 541593 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000608s ]