SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001121s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 597596 LIMIT 1 [ RunTime:0.000299s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 597596 [ RunTime:0.001701s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (584976,776869,1005520,212775,441983,862251,571001,700000,851642,603301,326934,77501,276115,620239,376463,152055,599149,973711,200029,754675,286098,257620,966079,827567,334014,520006,877609,667747,664632,371581,377932,271761,994605,306595,838064,97160,859150,41501,118007,589909,11180,155123,184486,796816,549512,359355,844267,580901,182787,318864,540670,1019463,420327,85159,85076,901281,182452,666596,132026,715502) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000954s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 597596 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000330s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 597596 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000540s ]