SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001089s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 544281 LIMIT 1 [ RunTime:0.003056s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 544281 [ RunTime:0.005046s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (300479,192282,717949,956481,938288,543171,399641,350254,686247,58092,280692,189471,671585,497337,334898,216617,690063,619793,570407,333238,955970,489137,363252,317774,421735,24839,371729,650523,319460,1017251,976905,494418,493114,977626,728595,289493,791122,959045,35353,296,481154,8469,644065,490368,668233,143559,1031907,534906,399223,368605,19893,328865,665069,687109,117542,144708,633797,788312,934349,897594) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 544281 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000526s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 544281 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000903s ]