SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001300s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402129 LIMIT 1 [ RunTime:0.000472s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402129 [ RunTime:0.001571s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (501610,1031023,386841,315490,312206,1027646,561188,195031,826463,530120,325765,683192,675034,591164,324367,1018336,245948,8001,757887,167862,225184,223668,712392,5248,413989,75772,811962,994595,830972,431471,354979,479623,568099,834808,751406,177382,966889,142415,185077,240940,374097,3708,926149,605648,578472,283592,779923,59832,750321,212331,220363,761489,758774,832476,341901,976762,325006,323086,705814,739752) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000944s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402129 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000439s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402129 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000441s ]