SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001259s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 104343 LIMIT 1 [ RunTime:0.000578s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 104343 [ RunTime:0.001630s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (958242,492840,1028747,115063,508736,111551,380818,578397,308691,699566,496152,606683,21422,428647,957495,323772,661956,123565,517245,73218,922263,1018672,665835,895340,100490,284286,724252,35459,639514,881439,535671,290278,868262,271505,798957,517983,203702,826008,170879,929316,1040904,312952,369235,257398,915602,499738,866471,50225,75886,432475,739678,307360,332373,753032,296376,755076,462666,139504,192029,897227) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 104343 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000409s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 104343 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000710s ]