SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001101s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 52274 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 52274 [ RunTime:0.002027s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1040333,433308,1891,714696,680660,562663,627270,378153,184086,487051,460406,404326,673219,122092,571961,953061,427793,753988,11197,1027200,26874,27452,783787,577959,241503,585652,36528,718247,111094,1021423,594713,266690,441175,891710,308940,980582,159063,253160,353598,952583,299652,785375,1047585,482614,151293,961982,714780,659380,599533,994969,690876,15614,634366,674738,598185,699388,101245,190010,805078,1045490) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001043s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 52274 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000332s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 52274 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000566s ]