SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001256s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 135653 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 135653 [ RunTime:0.002781s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (411727,244582,148747,967594,691872,248123,364022,608151,497259,111681,584885,817675,234080,300442,1026684,344758,387086,593111,229655,706047,257270,1003007,828000,508249,1038168,1012735,549260,375795,165280,33197,374663,837927,201593,429378,668606,819328,471575,829915,572752,1002420,492177,628558,886402,10675,1015959,132016,894894,675200,833116,375016,495003,396887,1046409,1022613,858671,962907,125938,153960,96355,107676) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001656s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 135653 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002049s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 135653 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000637s ]