SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 515236 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 515236 [ RunTime:0.002937s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (181700,781814,530067,8068,467244,282042,363084,779593,11569,191690,134520,530446,44206,984882,340665,826282,82822,764144,853024,526298,1048286,512515,907184,729730,47907,976095,997283,231402,88675,889346,629421,282445,715509,295168,859652,716152,801489,902367,931480,787265,391618,923874,272386,292392,140058,802411,458467,634229,809932,662507,1023520,961053,622005,949911,458147,670234,335318,851189,126223,511565) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001446s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 515236 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000440s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 515236 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000628s ]