SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 511493 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 511493 [ RunTime:0.002099s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (472424,206100,310928,667977,583289,257240,622480,25153,129932,586426,126146,569994,226840,565085,702068,704375,293602,142203,106632,295687,252639,486030,993738,853081,649202,569487,870641,596444,749791,886058,814074,413897,953875,813728,878706,201511,883179,475457,930422,391085,906569,983054,1008318,119733,962043,968661,146137,219679,309518,842227,808147,657683,610668,1031750,1029087,698821,598854,499337,914714,648763) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000988s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 511493 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 511493 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001686s ]