SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 522917 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 522917 [ RunTime:0.002216s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (462774,582970,167229,442074,485075,382652,940346,378451,273562,458380,301949,83692,1035776,573127,369522,430876,321039,480841,418910,938752,185844,620412,606509,476165,29039,853693,310731,235779,627660,871125,109603,98961,453220,358507,734605,669327,810104,562553,725262,751325,312980,620912,665216,208125,740163,903202,399336,842687,331415,990282,74587,215798,258242,320320,208800,306600,79465,352349,437218,1013891) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001011s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 522917 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 522917 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000448s ]