SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001820s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 801011 LIMIT 1 [ RunTime:0.000620s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 801011 [ RunTime:0.003038s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (845462,397294,632282,917935,627785,427791,28448,978947,96214,159149,44757,828207,805497,863167,59096,779188,700382,811469,1047272,215826,631803,542190,456731,803411,422366,308770,41768,864934,69599,241628,632584,38820,864738,1014466,64941,595438,546592,319517,192893,392546,825792,815546,869063,103261,184812,154196,186296,759510,379379,499429,971292,187136,745110,367607,751004,551870,527490,902748,899028,999750) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001095s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 801011 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 801011 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000960s ]