SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003735s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 681084 LIMIT 1 [ RunTime:0.002853s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 681084 [ RunTime:0.001966s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (124184,62344,934367,515025,206311,518809,3696,512639,94250,358700,1029310,127230,532961,400872,343018,172920,697236,131496,663954,414909,511724,494695,217540,355604,57768,1017456,891243,141741,922710,169720,860668,697174,606257,450848,957044,160310,64758,959667,638804,967436,775084,871539,262218,1034515,391402,988505,171845,957601,1008888,95502,374397,66350,267082,849381,22282,313461,544203,337470,630365,547328) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 681084 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000444s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 681084 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000539s ]