SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501961 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501961 [ RunTime:0.003127s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (198635,694487,178908,225383,982882,151802,607380,92385,57176,77592,551374,54426,231940,275532,160640,169053,890744,840518,870083,562510,882905,19546,621714,779558,206224,913364,890059,674270,53156,151636,504954,458300,390953,229444,849075,648488,975707,749771,824467,760685,318046,493913,448984,579389,685769,534706,698338,267293,999550,146525,431989,968619,920948,724159,581067,886723,162771,908832,885903,823171) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001038s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501961 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501961 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000638s ]