SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 441816 LIMIT 1 [ RunTime:0.000542s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 441816 [ RunTime:0.002880s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (123252,201272,1016333,332494,767136,146023,648831,203234,786256,958346,384193,471959,925251,398174,511256,382165,264084,208879,555428,62502,166547,938801,1025127,13869,923357,274469,527316,566831,53407,331826,109962,539789,460021,190916,494539,618127,870124,166461,59413,1040579,605632,488528,323594,582519,43915,78431,583068,964393,156814,261749,927026,256717,22085,430544,386775,16220,119757,338439,79739,860795) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002029s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 441816 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000448s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 441816 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000595s ]