SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001606s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 285418 LIMIT 1 [ RunTime:0.001109s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 285418 [ RunTime:0.004573s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (749679,971352,551861,639926,260909,530957,973786,283545,976917,414626,124209,507644,380180,684838,902003,229238,866701,372891,374012,538023,628142,342503,531947,761691,632080,851136,789538,628512,190094,312123,951845,110279,502424,472630,104961,852811,533531,203420,644235,1001225,485332,75677,519477,352462,231933,826912,706266,798239,776701,513507,195278,903510,231957,861121,538362,1012924,130799,675446,281228,550898) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003272s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 285418 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000997s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 285418 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001006s ]