SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001332s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 150317 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 150317 [ RunTime:0.001563s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (546505,573462,110964,616993,500582,968251,952658,322091,890859,977123,553496,116978,770603,946501,200910,669404,699468,934964,87981,292438,880541,987075,568393,353147,627201,332480,955758,903297,603949,380826,776038,437269,510639,85027,142453,862813,92470,133107,17215,671612,509411,696676,926009,164300,979488,901783,603416,900462,676361,537984,295403,18227,950364,278306,422172,789381,800792,855874,307644,250743) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001487s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 150317 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000736s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 150317 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000492s ]