SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001280s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 489215 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 489215 [ RunTime:0.002054s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (682270,497214,593150,956905,942217,308251,320907,565250,289718,527019,682952,1007672,895605,832309,358873,634272,677318,898,670534,398700,371086,432605,757223,452604,619455,541413,252150,742623,489355,446987,864166,111811,740543,635313,206072,905863,43374,948588,472279,553514,167183,50096,277245,798313,239931,661542,111594,989025,305436,980900,634147,84226,204193,839603,976156,249338,13203,189516,377611,905250) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001450s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 489215 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 489215 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000674s ]