SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001124s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 41589 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 41589 [ RunTime:0.001548s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1005052,1002619,767038,1008480,1019361,759698,568613,104788,823320,234081,871117,817482,610578,804005,933547,8416,839612,411923,602333,754442,954821,986752,877625,1025437,80763,443759,428786,608356,562421,285682,84888,419158,764596,257949,740944,113631,377877,245036,806911,480268,195346,1010938,34437,630963,275172,1031430,116169,178999,862487,301629,379669,309455,237342,513354,860901,538610,957768,905934,718323,471111) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001047s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 41589 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 41589 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000529s ]