SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001434s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 428051 LIMIT 1 [ RunTime:0.000881s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 428051 [ RunTime:0.002937s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (331535,939057,55611,885338,237468,354071,368565,147709,408167,685658,450771,744672,222170,909719,579312,84275,727373,691870,977234,135964,883969,1048214,699447,486297,763506,322077,413824,684595,238263,3410,701553,1011596,156984,494927,613487,235541,72099,526930,395141,967222,339557,868935,405229,920581,786702,865150,677536,73297,106835,316935,1043289,988121,640091,481840,1041165,526665,544180,407255,433032,245544) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001987s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 428051 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 428051 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000556s ]