SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001189s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 341071 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 341071 [ RunTime:0.001779s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1004254,836110,55141,732164,483158,95359,531115,128519,342710,782194,139901,327044,796781,408232,966979,114218,836634,975673,159507,787311,518231,901568,586654,245797,509281,480567,253502,741186,232717,972664,988867,699117,181831,387082,268474,974319,470568,307431,218837,270232,979143,489165,536290,1012127,226894,559889,358053,313238,805288,705473,745727,7000,901819,524729,717188,175446,101801,280887,511919,664552) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001046s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 341071 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 341071 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000687s ]