SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 264053 LIMIT 1 [ RunTime:0.000418s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 264053 [ RunTime:0.001655s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (904950,816859,276988,799819,748509,233648,369041,43779,649096,290545,687630,462725,165227,812452,882023,174075,775184,184776,1038621,669463,171221,686779,79744,598750,812191,73207,409747,847870,971667,467505,187704,712134,565153,668882,533583,1041512,405329,907175,783793,776305,243181,326545,678764,762171,649569,586463,662077,684413,14001,354678,307192,250899,986171,631231,695041,182912,84244,18518,49975,601262) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001567s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 264053 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000417s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 264053 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000641s ]