SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001266s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 132008 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 132008 [ RunTime:0.003508s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (124068,948089,431575,468671,649411,646867,79835,618527,432958,833895,827199,407906,489354,54390,120513,206817,458631,5140,1001467,971961,235028,345418,436035,130977,292920,174297,396241,937870,980384,650546,887642,867172,942173,336712,550910,866334,1039118,169819,688304,422092,594065,336274,498690,340385,585103,41126,716740,786251,716269,325601,246480,487578,781238,564437,268193,505554,294010,223554,24280,258521) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001033s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 132008 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 132008 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000647s ]