SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001109s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 404029 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 404029 [ RunTime:0.001774s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (68735,49174,979169,1011341,990879,416070,314022,607134,767483,467216,137161,649594,150193,178491,982159,121498,474749,875305,286007,418289,534467,283409,587709,910600,247403,18434,389201,753640,786488,66907,218184,615172,1046990,136652,792751,758125,931969,825463,21017,9709,262233,888307,615050,350520,278881,306950,353009,474615,15772,866739,334529,702452,211920,1005843,1047449,399096,296712,555260,928600,632584) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001059s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 404029 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 404029 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000567s ]