SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001296s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505428 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505428 [ RunTime:0.002083s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (133054,82301,601175,594162,1017117,228097,913389,439431,6890,860905,570629,342889,1046670,226769,8400,650248,480115,526727,1027747,185465,350229,13658,407376,312208,615868,959371,876624,334276,849858,705632,382574,872917,451535,988148,59837,163890,85263,798105,640799,412025,790039,127401,251877,296444,191503,946305,801086,702385,239672,421561,362701,444755,149031,315491,111825,391672,128945,240863,286208,1820) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001072s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505428 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505428 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000679s ]