SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001333s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 32341 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 32341 [ RunTime:0.002015s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (545038,479539,431136,647774,822065,302905,562170,1017314,261649,573719,738595,430706,537633,893100,605959,721903,278210,517000,538356,586522,168133,915157,570760,160268,296810,1029594,329506,542964,139129,842642,652671,896207,144773,352180,152215,5258,312724,1014609,457756,10104,629417,751574,315947,820160,233114,586378,730092,328219,961330,5634,256313,606919,340466,28131,552344,523159,116464,823063,105185,151081) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001243s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 32341 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 32341 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000615s ]