SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 265986 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 265986 [ RunTime:0.003484s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (465083,887357,271555,136344,453295,592394,756496,126117,23484,563195,104938,428784,341065,239741,860799,866666,735262,830999,281568,326408,238381,808826,722191,873811,985549,237478,1039698,1014500,48348,382790,642350,929830,829478,1035528,201369,988647,917223,885385,617317,764212,234889,105896,115764,898553,150585,97038,386621,522954,629663,416952,13950,340783,234443,110662,931832,621292,150624,804485,634127,848221) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001053s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 265986 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 265986 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000512s ]