SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 318370 LIMIT 1 [ RunTime:0.000300s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 318370 [ RunTime:0.001953s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (330552,251546,383857,439249,262838,430211,189894,37589,349669,1003710,4252,65800,708475,922596,262990,595365,41333,225126,733180,1854,620103,315343,1041353,546417,188877,700798,331259,1036572,809406,834714,356165,504952,653651,196119,733893,134423,829451,754920,208035,572959,637077,960322,152367,560627,966877,418529,886448,52611,829863,579987,379483,568519,958992,543065,72355,534454,505608,345366,84659,993790) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000966s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 318370 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 318370 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000511s ]