SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 443143 LIMIT 1 [ RunTime:0.003421s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 443143 [ RunTime:0.001774s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (951022,471418,959314,113150,306710,329774,857240,876111,778779,602897,382816,835063,882007,285476,888526,530876,166662,510622,453288,264194,437772,4149,908354,684043,148482,988238,929329,533892,580926,258579,869078,604677,56171,892859,501796,271663,125451,200701,768687,25611,724386,577973,13144,807341,744175,910500,97243,69613,665864,943428,77133,233218,835391,1006082,303757,469578,467071,560241,435438,644163) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002961s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 443143 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000467s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 443143 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001119s ]