SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002433s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 204001 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 204001 [ RunTime:0.005858s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (97057,473131,578646,556700,199174,1002339,448630,781715,469062,803997,496202,134553,835354,827560,602862,670870,111035,140898,725863,231980,175452,821006,111137,138871,379356,227707,2908,255106,820485,928610,532918,722777,878847,181513,319309,490161,766297,639818,222214,52151,840683,1028165,381722,142818,919110,166838,494406,919367,764386,352814,158231,641709,896000,586642,142176,386890,16472,634234,690653,754949) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006520s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 204001 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002868s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 204001 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000593s ]