SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003719s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 422200 LIMIT 1 [ RunTime:0.000408s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 422200 [ RunTime:0.001810s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1041595,391652,675950,430515,546894,691623,231096,636555,102296,1048048,902638,478438,784847,585660,128995,822269,655957,303449,337025,988207,848425,83043,453327,285766,1042147,325970,1027304,809760,793526,656749,660691,640158,504049,219535,538529,562108,334134,368299,216075,480770,124714,847520,90636,497216,1030489,920082,402679,981569,474825,666663,170321,982476,1003798,476343,195507,100353,252574,798429,891368,813505) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001266s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 422200 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 422200 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000441s ]