SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001117s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 774811 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 774811 [ RunTime:0.002774s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (696832,1046942,290892,962696,336087,974931,781511,343349,782002,978360,319219,68720,253474,505746,433579,514044,487446,81144,180993,1042146,43777,641197,424919,147151,1047449,695679,256033,900127,512905,317474,184323,427805,493348,896510,90090,384701,1018403,673064,958545,256496,1015769,707048,151772,126790,1009402,987617,459522,123967,125084,94869,201225,862462,276537,387173,120314,788091,978600,111837,517427,948113) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001082s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 774811 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 774811 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000572s ]