SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001113s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 107785 LIMIT 1 [ RunTime:0.000285s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 107785 [ RunTime:0.001873s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (341586,42772,913618,428334,726187,706512,50435,352147,326016,603555,31010,943672,12225,251416,152634,9840,901773,210903,92576,306705,500752,233359,927040,50743,865472,189351,910776,659422,519007,164021,447598,105003,128666,633499,985437,627080,1010186,449858,119375,705141,69239,925643,141919,565487,323756,669446,642881,123365,993582,879033,752999,259583,770774,123853,676978,1024371,905768,614692,290645,546640) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000946s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 107785 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000336s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 107785 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000611s ]