SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002498s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 256404 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 256404 [ RunTime:0.002249s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1048053,560103,859779,674348,248029,1017427,433538,105601,431245,57905,1024177,770981,367909,586533,530671,973306,280070,176630,988495,469313,909635,648229,703470,354672,720695,711149,275008,236575,880061,178159,739614,698749,408813,939755,446555,988178,347267,807014,267503,851550,474832,979630,127769,920692,536921,445857,933927,407230,141384,740058,20496,168339,283444,284217,710108,617744,232968,720875,305117,154260) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001024s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 256404 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 256404 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000620s ]