SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001621s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 681621 LIMIT 1 [ RunTime:0.001100s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 681621 [ RunTime:0.003106s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (378613,23619,682279,705582,536309,206070,686279,831533,650420,528214,178378,574022,602655,231592,490385,694069,616477,427793,467178,250087,1001784,432767,264831,482714,964419,640800,195347,982125,278104,95830,495385,577096,676252,728152,664782,1040886,673090,230620,774513,937286,627145,348621,989099,1015038,336232,919465,793644,764417,827711,786858,81045,124743,645515,682641,79581,391797,363001,803523,993143,306138) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001990s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 681621 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000434s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 681621 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000733s ]