SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1012494 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1012494 [ RunTime:0.001950s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (774666,980882,530628,332273,582038,765399,901507,770397,620499,802040,284949,483206,1022135,20446,595790,1020027,414309,647642,540573,657795,709557,841584,773648,130361,825778,573779,1026341,870767,402976,58928,74550,776463,844384,210690,510475,143522,138253,792074,567630,148176,433094,842417,208096,135464,705047,333157,759058,270487,655896,976546,526006,704650,107565,676595,814131,407746,650470,926744,501309,132010) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1012494 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1012494 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000645s ]