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` = 504498 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504498 [ RunTime:0.001829s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (714063,539186,628804,409739,882060,114096,733276,458839,749028,1001646,899338,620160,563508,193214,738098,655534,904066,643762,21484,24118,987281,569529,967651,208460,664628,711811,470936,103847,800622,229890,483297,142266,966619,928812,231069,158296,335366,768827,560284,634939,504824,813653,86052,686330,126165,370529,184163,428856,81758,403191,747083,238318,579351,777736,52833,308037,396050,23729,428154,466785) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000982s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504498 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504498 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000553s ]