SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001131s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503952 LIMIT 1 [ RunTime:0.000285s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503952 [ RunTime:0.001739s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (358063,398169,225747,206829,847978,392852,52510,550494,541795,180523,863659,174023,337975,175545,232960,43449,456008,256021,534862,1020139,604389,423521,792197,895705,396439,876793,210704,647458,603155,213856,1001162,165283,219574,756897,460858,807849,359599,863729,303132,324217,568542,959211,698190,1032820,737875,359647,576986,825562,440695,588133,1043106,893756,4108,440834,387767,901794,534881,399359,152311,2958) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000959s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503952 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503952 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000557s ]