SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401441 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401441 [ RunTime:0.001448s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (222296,234412,283694,153513,457176,321708,918252,263211,300908,640190,524783,525102,403659,551308,1695,383190,146340,664826,679068,382024,350228,525920,622244,698871,27733,832817,160769,371733,125959,44054,593746,129024,141860,162819,116962,367236,320645,507853,738134,128411,726041,845274,864906,158461,724121,1012410,141230,688521,967420,565403,76972,587988,264498,171493,375793,392418,356176,957674,919771,573782) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001083s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401441 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401441 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000567s ]