SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002116s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 563805 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 563805 [ RunTime:0.002913s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (251174,736082,489497,437709,112508,154085,420808,432753,807476,29336,437812,291948,779648,743829,409678,726534,499113,124078,974803,935307,815765,1042218,570158,606014,855866,249933,510044,19707,523401,914154,485731,1024908,416988,622111,833014,527831,675000,19457,599523,603781,368029,249668,161771,449691,647,769001,19443,196305,175259,106100,772152,37382,336597,892076,523148,255961,394833,637372,808106,1025323) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001268s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 563805 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000415s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 563805 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000556s ]