SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001192s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 530092 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 530092 [ RunTime:0.002893s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (492986,157225,505517,1044159,91719,931703,1015315,435593,194781,589542,414788,1019331,884430,773704,389870,956416,184393,206353,790363,228272,517130,651002,958759,630230,207372,5860,879411,429391,992994,146240,1030362,891126,743949,860532,783386,728147,31748,708827,144731,762529,845759,761952,1028734,576234,424618,457038,970135,336171,518496,237171,1005332,749321,994914,293450,878654,2031,583057,928931,1038655,645203) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001112s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 530092 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 530092 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000612s ]