SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001327s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 358992 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 358992 [ RunTime:0.002649s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1030982,792631,250421,406844,971445,865918,776747,722442,998797,550024,285017,203618,703346,312194,575247,983001,495394,997175,732331,97459,447116,76668,931731,636330,658443,189915,678624,368975,726002,906766,709952,255480,443997,831733,531494,354040,518998,426856,664275,61021,801883,612582,486808,622832,168066,215286,615453,264541,200468,291392,1011869,923086,396506,981589,416741,477058,697102,605637,833911,716251) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001740s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 358992 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000536s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 358992 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000591s ]