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` = 515470 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 515470 [ RunTime:0.003536s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (734933,129058,497892,632201,869328,893293,207883,694304,594684,157072,648309,101774,991725,560156,590270,502569,557010,949671,574339,773010,960563,1036019,944985,329719,59415,39745,971382,956522,88456,265243,921252,5515,312816,99120,422997,166080,86737,90048,39376,85025,760260,429844,979274,954318,990623,492880,393393,285335,476490,587708,325294,566531,283206,136375,498106,966809,426320,266342,970656,341339) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001006s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 515470 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 515470 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000428s ]