SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001565s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505425 LIMIT 1 [ RunTime:0.000437s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505425 [ RunTime:0.002132s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1041426,657999,173905,752722,243032,246775,1039339,863357,1040576,663521,289845,419442,908113,882567,72164,489731,309236,122585,743897,617680,289039,800668,790648,81098,301193,351397,427424,372204,182079,193966,711188,1023347,38603,501506,12283,183320,856375,234570,51062,561658,166943,621594,1048765,545164,641510,685456,605717,391361,459226,181505,890596,1033890,883136,358175,543953,887939,435465,877807,154876,997195) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001332s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505425 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000416s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505425 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000628s ]