SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001036s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014611 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014611 [ RunTime:0.001970s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (123749,599509,681175,500697,218088,782495,101795,362491,87955,554557,977818,386742,136861,792021,32312,89470,164569,448354,513489,954012,262119,702422,265426,82958,35184,612472,572864,657444,268530,920654,356493,296859,443162,307128,302082,199854,331806,348966,151386,355045,786332,427796,216168,932371,699225,626501,299890,728082,376529,140118,75791,631510,518599,920194,849732,694668,342528,120428,465782,76421) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001095s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014611 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014611 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002340s ]