SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001329s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504544 LIMIT 1 [ RunTime:0.000420s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504544 [ RunTime:0.002934s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (714337,660959,978776,716544,513965,932263,945952,838944,787950,810077,1020436,515472,124761,460895,685720,771614,483188,360326,105810,39474,936205,685659,296400,567866,569634,619258,31095,215258,565034,537850,645918,682319,244273,165715,892124,69430,406660,711245,489722,683169,753774,834860,283514,604470,530074,237124,90057,739904,738177,888339,260471,105748,1001302,1012552,22105,102998,902856,170067,802083,260953) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001535s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504544 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504544 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000531s ]