SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402798 LIMIT 1 [ RunTime:0.000479s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402798 [ RunTime:0.003354s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1040370,1011312,190143,39886,585441,501451,637909,999916,993268,592358,359246,543704,499943,180867,512007,332465,207490,154087,785027,235555,16292,44408,268478,755976,286047,794547,642902,592910,323858,257818,239609,1015306,460387,618981,356731,62936,231111,130744,66041,134567,947706,468315,915274,61630,473652,360595,152509,257501,682721,753117,749369,167567,93789,505652,602317,956830,933184,378580,201433,290512) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002066s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402798 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000856s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402798 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000677s ]