SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 528311 LIMIT 1 [ RunTime:0.000633s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 528311 [ RunTime:0.001981s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (364711,324685,772987,1033279,548191,374936,673330,538866,209727,15675,928703,156730,513643,511647,367352,445659,419336,1046474,590228,47837,982039,51704,577709,275368,332444,644,210112,824758,312057,531916,900717,985085,225705,422673,807929,926912,120469,361817,431602,970206,706615,59945,567902,627571,543437,184989,927704,745408,6862,611184,962438,590723,891551,353359,405109,801210,499721,498612,74717,256391) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002512s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 528311 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000460s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 528311 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001176s ]