SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001108s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 432027 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 432027 [ RunTime:0.001498s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (751201,381060,106801,48326,525796,386963,861184,994633,252547,898840,186185,439741,591491,926731,305437,606874,742750,947949,564429,787202,858028,304632,254349,437295,382529,573153,426624,740780,671068,49857,818509,434348,238988,294800,132577,909201,990698,902409,736999,532695,58258,692209,985327,57444,19415,212198,627125,86388,97111,98066,642175,482878,587282,292811,209104,598505,237000,524314,357306,614453) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000979s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 432027 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 432027 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000593s ]