SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 38139 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 38139 [ RunTime:0.001590s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (748707,673037,366092,1015634,396876,798972,114550,128480,573313,173915,49174,639026,100755,1004080,921064,802519,790684,790784,386059,164284,742390,68783,398336,937352,425681,393123,182917,379514,10997,963599,948347,174473,642229,253454,215114,764102,558935,545768,783678,591967,76213,848968,641227,934365,400713,7930,273179,682456,382795,103220,527206,557616,1018240,74353,830543,759650,526452,942105,246376,956308) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001051s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 38139 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 38139 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000526s ]