SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001219s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1015201 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1015201 [ RunTime:0.002574s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (279463,738791,236758,508390,454355,681063,536528,772437,839285,70425,515359,407272,552119,203021,629328,280102,1035309,581781,287614,834532,580342,700087,391533,138908,571165,186216,96399,768888,592347,281066,369455,230133,60562,259947,815764,396669,1019012,783434,820201,807734,163460,236892,61405,736412,257435,415788,855042,938742,321373,1025834,979146,966550,575145,14786,627849,43584,109297,15349,67790,667129) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001290s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1015201 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1015201 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001018s ]