SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 468429 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 468429 [ RunTime:0.001585s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (616887,868543,184199,768577,489353,559673,1013787,401817,186000,820196,230874,535113,295092,953239,313932,638516,746217,415836,997627,164528,728058,808214,581502,425100,635106,899057,706049,811194,474824,149933,1046274,327793,264234,28657,153430,1028892,295425,839580,542110,534885,309096,1036036,786299,147423,775959,890069,235511,917700,833537,831491,844750,578015,248924,1007863,72746,1023066,569410,790927,92725,22867) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001060s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 468429 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 468429 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000415s ]