SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002001s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1043527 LIMIT 1 [ RunTime:0.000415s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1043527 [ RunTime:0.001697s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (487456,724924,998254,2594,975332,1010652,618474,978782,725779,408703,836415,973614,168785,237198,264374,174234,421672,403984,768966,572898,734792,412784,493483,992127,238599,540381,306449,625509,22689,952023,759277,581397,563453,1713,1043447,344318,422119,104738,15139,811430,354361,617110,281581,966577,103223,700198,964180,803951,767768,511814,388158,233913,679216,242228,622504,1015931,297681,603085,921767,840370) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001031s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1043527 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1043527 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000504s ]