SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001156s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 536753 LIMIT 1 [ RunTime:0.000344s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 536753 [ RunTime:0.002314s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (70078,786726,906959,651776,882164,866121,81761,348426,628401,674311,313701,1017837,344553,512409,921400,69751,465674,1030990,197836,278120,192373,980927,20374,959361,741043,994813,162287,734563,133695,113305,759692,323918,438650,946254,219488,56859,59172,54857,599923,211809,741834,20327,849231,583188,391877,787525,745017,641076,296216,700087,300785,914575,180400,214926,673570,501193,6452,71536,163501,751433) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001490s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 536753 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000418s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 536753 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000609s ]