SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001171s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 470519 LIMIT 1 [ RunTime:0.000842s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 470519 [ RunTime:0.001705s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (324108,291449,198651,222543,509087,433220,688813,570167,645456,890829,724140,936000,619901,457596,266870,170329,1034905,761380,21603,74303,1019224,200259,138692,1021032,589105,605321,958642,909797,644108,484352,591372,698860,28206,911495,843909,71577,275936,461447,632361,692866,547481,566646,682648,283518,1009704,475604,654406,429776,806667,571397,590539,124259,520024,378890,709965,565617,1040590,959325,83267,1022162) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001047s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 470519 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 470519 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001354s ]