SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001286s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 349684 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 349684 [ RunTime:0.001701s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (245800,264558,667313,437727,727957,1024,842968,883344,623,1031076,1022111,226168,883656,291550,1043816,1001217,43514,99193,911502,998483,961153,721136,135201,860141,144061,328280,660110,128408,417459,143658,375638,194944,41093,559952,168148,264382,237456,629811,406800,972035,836640,693609,382630,355424,745282,772242,326206,21099,691434,909526,104273,601439,990500,417744,239890,450516,734572,281730,1045955,776875) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001076s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 349684 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 349684 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000720s ]