SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001256s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 100776 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 100776 [ RunTime:0.003516s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (342013,1005145,653370,486623,612142,990859,244470,307573,799374,945081,828634,955180,584492,971030,694686,24574,706923,387213,708305,569589,318637,498514,1016028,864401,782133,594386,987652,903687,570249,323837,773352,941416,397262,203278,21646,564275,251179,922793,236303,548162,946949,102636,496398,358511,517177,393825,157798,644494,137560,655639,862701,787277,237881,441113,869615,335446,2824,30333,917131,425488) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003771s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 100776 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000334s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 100776 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000693s ]