SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003623s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 4838 LIMIT 1 [ RunTime:0.002661s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 4838 [ RunTime:0.008167s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (542434,944963,416237,75748,482789,1013975,273000,460642,28508,181906,221822,257051,268382,174014,529358,791331,652267,912882,317503,538341,960159,918129,117052,596825,930653,452227,491463,84137,119517,198160,29996,118024,569371,284148,963592,793685,436150,268824,1029501,385383,462186,690187,17047,559836,837094,834583,926888,308084,580598,905481,307230,579073,64469,302517,177904,40064,751938,503404,187016) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001098s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 4838 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000520s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 4838 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001441s ]