SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 264008 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 264008 [ RunTime:0.001599s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (771599,231877,150578,676083,447891,302243,895401,301416,388278,272625,657090,593106,400871,437497,842141,95515,150723,232937,132631,738289,350347,53447,930530,305347,203156,791862,312601,169184,572835,978200,491481,660843,992325,16852,319575,940896,200793,221934,185121,171043,1006073,857047,280273,806968,154541,520181,75859,111767,255050,22471,189556,18321,319137,358704,972788,903782,8201,797306,477895,16879) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001045s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 264008 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 264008 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000370s ]