SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002721s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 520086 LIMIT 1 [ RunTime:0.002887s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 520086 [ RunTime:0.004855s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (101752,665463,343368,588174,159414,981771,737834,111399,926339,475980,1011730,296369,381295,277308,1023492,306680,726042,231015,733171,765572,113209,911049,731235,987056,918279,405074,466616,880136,1001974,362438,1016114,766179,688233,611837,1021382,909622,543573,297231,147775,468606,472553,87892,4314,594177,56588,522937,837795,113101,20390,705438,803482,751225,14044,17478,395637,438034,673200,486656,55800,574848) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 520086 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001760s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 520086 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000610s ]