SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001296s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 410946 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 410946 [ RunTime:0.001889s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (775995,376724,959125,742319,71943,493853,942081,199525,936230,309082,937623,696177,87055,290083,357299,705125,641702,306922,780953,119878,1041950,799950,762705,363753,563755,1018390,498007,159450,241019,584229,391409,784326,897902,374906,820323,607861,278960,617578,426949,840351,272298,1047478,182495,869153,148665,183090,773707,618969,721268,550703,621120,887245,45487,793644,767226,457522,205219,1021979,153505,430434) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001031s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 410946 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 410946 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000619s ]