SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001222s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 420814 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 420814 [ RunTime:0.002477s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (557780,897072,554972,268057,540367,183570,259180,760843,965509,1016325,844195,453598,390921,436370,279258,302020,682876,4276,812497,889816,490310,850878,724912,604846,141761,984091,57977,164798,964989,317544,807749,74521,405015,366895,828142,671340,616444,432239,1011534,854942,665191,564107,980035,235879,676525,718792,421593,997749,410584,354096,760161,915509,187951,402001,925949,882424,291552,824660,437747,522487) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 420814 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000502s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 420814 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000536s ]