SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 599691 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 599691 [ RunTime:0.001800s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (456030,169354,232648,525052,359969,199900,874938,232840,137567,641508,717414,141035,714795,964077,745642,690110,1047472,912656,766646,273685,478329,106630,855351,467710,19788,696200,41858,782560,66955,487894,377129,979240,253627,311062,877859,981889,1023557,525241,761924,105728,635162,333403,6069,501049,382049,184783,78736,237562,692738,807224,551939,625061,702768,968131,302185,792325,547334,971059,469701,470406) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 599691 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 599691 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001674s ]