SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 554028 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 554028 [ RunTime:0.001635s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1015712,584086,213256,653668,449418,614282,264408,325588,173113,1047978,694894,721067,302787,37563,342045,483680,961080,776696,387720,898486,314841,420163,334844,433160,68389,290224,497951,3738,397600,823076,733567,178761,567005,17651,257191,1019763,178981,647358,109893,194303,406589,973429,888731,604171,961803,333443,247190,557789,887986,111434,245086,275498,210438,611890,320913,626683,182798,498439,886125,416932) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001046s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 554028 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 554028 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000456s ]