SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 42461 LIMIT 1 [ RunTime:0.000406s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 42461 [ RunTime:0.004104s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (478155,869635,1016814,570339,559824,733185,393149,123992,853557,435161,584999,206248,103685,143122,773570,788453,1039376,174596,491948,388496,607420,744100,492925,535255,955306,28797,97625,375033,879265,499431,863117,787721,409373,832497,757846,744543,519130,107676,294668,273911,448787,760107,71972,711739,359152,896775,389520,191552,142987,874931,425151,128936,49943,538651,799432,139793,374657,968143,598458,882148) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001086s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 42461 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000846s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 42461 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000451s ]