SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001106s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 471987 LIMIT 1 [ RunTime:0.000290s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 471987 [ RunTime:0.001613s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (415332,309592,580549,521473,11091,342003,84510,837462,925605,1034660,54657,273453,39940,947545,621697,828870,582092,690709,548236,299455,873914,584983,107830,834964,713010,789664,845387,528737,542483,293172,647354,915636,155481,742016,643114,564014,84050,1038776,904826,166474,690998,987729,831128,394980,1015596,174015,921487,557377,210763,41906,1024285,704928,338485,673767,275691,478655,907297,655,280732,523457) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000916s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 471987 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 471987 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000447s ]